How to get Max value in Access or sql...???
column Name :- receipt_no
column datatype :- nvarchar
receipt_no value is 1 to 1945
I am trying but result is wrong...
every time return 999(because 9 is grater than 0 to 9 for ascii reason )...
Thanks & regards
Manmohan Jha
Manmohan Jha
29-Apr-2014Access Query is :- SELECT Max(Val(receipt_no)) AS rcptno FROM Receipt
Manmohan Jha
16-Apr-2014i also use:-
Select max(Cast(receipt_no as int)) From Receipt
Both not working in access db
Why???/
Chris Anderson
16-Apr-2014Select max(Convert(int,receipt_no)) From Receipt